<?php

use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class CreateGroupTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('group', function (Blueprint $table) {
            $table->increments('id')->comment('自增ID');
            $table->string('name',20)->comment('机构名称');
            $table->string('liable',20)->comment('联系人,负责人');
            $table->timestamp('start_time')->comment('机构成立时间');
            $table->string('province',20)->comment('省份');
            $table->string('city',20)->comment('市');
            $table->string('location',100)->comment('详细地址');
            $table->string('website',100)->comment('官方网站');
            $table->string('card',200)->comment('机构证书');
            $table->string('content',200)->comment('机构简介');
            $table->string('bank_number',30)->comment('银行卡号');
            $table->string('account',30)->comment('开户名');
            $table->string('bank_name',30)->comment('开户银行');
            $table->string('mobile',20)->comment('负责人联系电话');
            $table->string('email',50)->comment('机构邮箱');
            $table->tinyInteger('status')->comment('审核状态');
            $table->string('reason',80)->comment('拒绝原因');
            $table->timestamps();
            $table->softDeletes();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::drop('group');
    }
}
